<template>
  <div>
    <div class="department-container">
      <div class="app-container">
        <h3 v-if="$route.query.act==='employees'">批量导入</h3>
        <upload-excel :on-success="success" />
      </div>
    </div>
  </div>
</template>

<script>
import { importEmployee } from '@/api/employees'
export default {
  name: 'Import',
  methods: {
    // 获取excel读取数据
    success(val) {
      console.log(val)
      if (this.$route.query.act === 'employees') this.importEmployess(val)
    },
    // 导入员工操作
    async importEmployess({ results }) {
      const userRelations = {
        '入职日期': 'timeOfEntry',
        '手机号': 'mobile',
        '姓名': 'username',
        '转正日期': 'correctionTime',
        '工号': 'workNumber'
      }
      const arr = []
      results.forEach(item => {
        // item  每个数据对象
        // Object.keys(item)   中文键
        // 对所有的中文键进行遍历
        const obj = {}
        Object.keys(item).forEach(key => {
        // key是每一个中文键
        // item[key]  每个中文键对应的值
        // userRelations[key] 每个中文键对应的英文名称
          if (['correctionTime', 'timeOfEntry'].includes(userRelations[key])) {
            // 转换成日期类型，才能入库
            obj[userRelations[key]] = new Date(this.formatDate(item[key], '/'))
          } else {
            obj[userRelations[key]] = item[key]
          }
        })
        arr.push(obj)
      })
      await importEmployee(arr)
      this.$message.success('导入成功')
      this.$router.back()
    },
    // 时间处理
    formatDate(numb, format) {
      const time = new Date((numb - 1) * 24 * 3600000 + 1)
      time.setYear(time.getFullYear() - 70)
      const year = time.getFullYear() + ''
      const month = time.getMonth() + 1 + ''
      const date = time.getDate() - 1 + ''
      if (format && format.length === 1) {
        return year + format + month + format + date
      }
      return year + (month < 10 ? '0' + month : month) + (date < 10 ? '0' + date : date)
    }
  }
}
</script>

<style>

</style>
